﻿-- =============================================
-- Script Template
-- =============================================


INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
VALUES(10,'BACKBBS','BackBBS_System',1/*Grade*/,0/*NodeType*/,0/*ParentCode*/,'10'/*PathCode*/,'系统管理',1,0,-1,GETDATE())

INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
VALUES(20,'BACKBBS','BackBBS_Foundation',1/*Grade*/,0/*NodeType*/,0/*ParentCode*/,'20'/*PathCode*/,'基础信息管理',1,0,-1,GETDATE())

/*二级..*/
INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
VALUES(1001,'BACKBBS','BackBBS_SystemSet',2/*Grade*/,1/*NodeType*/,10/*ParentCode*/,'10.1001'/*PathCode*/,'系统参数',1,0,-1,GETDATE())

INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
VALUES(1002,'BACKBBS','BackBBS_User',1/*Grade*/,1/*NodeType*/,10/*ParentCode*/,'10.1002'/*PathCode*/,'用户信息',1,0,-1,GETDATE())


INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
VALUES(2001,'BACKBBS','BackBBS_NewsShows',1/*Grade*/,1/*NodeType*/,20/*ParentCode*/,'20.2001'/*PathCode*/,'新闻管理',1,0,-1,GETDATE())

INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
VALUES(2002,'BACKBBS','BackBBS_Plays',1/*Grade*/,1/*NodeType*/,20/*ParentCode*/,'20.2002'/*PathCode*/,'彩种信息管理',1,0,-1,GETDATE())


--INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
--VALUES(200101,'BACKBBS','BackBBS_NewsShowsTemp1',1/*Grade*/,1/*NodeType*/,2001/*ParentCode*/,'20.2001.200101'/*PathCode*/,'新闻管理的儿子',1,0,-1,GETDATE())

--INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
--VALUES(20010101,'BACKBBS','BackBBS_NewsShowsTemp2',1/*Grade*/,1/*NodeType*/,200101/*ParentCode*/,'20.2001.200101.20010101'/*PathCode*/,'新闻管理的孙子1',1,0,-1,GETDATE())

--INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
--VALUES(20010102,'BACKBBS','BackBBS_NewsShowsTemp2_2',1/*Grade*/,1/*NodeType*/,200101/*ParentCode*/,'20.2001.200101.20010102'/*PathCode*/,'新闻管理的孙子2',1,0,-1,GETDATE())


--INSERT INTO UARightInfo(RightID, ModuleType, RightCode, Grade, NodeType, ParentCode, PathCode, RightName, OrderID, LogFlag, CreateUser, CreateTime)
--VALUES(200101011,'BACKBBS','BackBBS_NewsShowsTemp3',1/*Grade*/,1/*NodeType*/,20010101/*ParentCode*/,'20.2001.200101.20010101.200101011'/*PathCode*/,'新闻管理的孙子1的儿子',1,0,-1,GETDATE())
 
 select * from UARightInfo;
 GO
 --TRUNCATE TABLE UARightInfo;